2014-11-14 - 15761.100 - Enhancement - Change Service Level Source #SalesDistribution
ENHANCEMENT
15761.100 - Change Service Level Source
Purpose
Need to add new fields to service level DSO & change the logic for key figures in service level source.
Admin Info
Purpose
|
Need to enhance service level source with the new fiields.
|
Requested By
|
Mark Harris
|
Spec Created By
|
Uday Kumar P
|
Spec Created Date
|
11/14/2014
|
Spec QA by
|
Uday Kumar P
|
Objects
|
Service Level Source
|
Document Status
|
Complete
|
Estimates
SNo
|
Activity
|
Estimation in Hours
|
1
|
Research
|
32
|
2
|
Documentation
|
16
|
3
|
Development/ Config
|
32
|
4
|
Unit test in DEV
|
10
|
5
|
Unit test in QUA
|
20
|
6
|
Transports
|
10
|
|
TOTAL
|
120
|
References
Prior Tickets
None
Documents
None
Spec Changes
SNo
|
Change Details
|
Requested By
|
Requested On
|
Notes if any
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Functional Requirement
Purpose/WHY:
Email From Mark(10/16/2014):
1. The first estimate I need is for the following logic added to Service Level.
All materials that are non-program (season based) for customers that are not-routing – (customer group 2 in the Additional Customer Data SD) (<> 157 - Routing) will be +3 only.
All others are still +5
--> This includes all Program materials
--> All other materials where customer is NOT routing.
We would need to get season based on specific criteria we are still defining. (may be based on a selection of the first digit of season, include 3xx,4xx,4xx,…) Or the other choice may be to define which seasons are “program” based on BPC groupings. I am still working on getting that clarification but please look into both ways.
--> By +5 or +3 I also mean weekdays. Uday had confirmed for me this week that we have logic to determine weekdays and not include weekends.
In Scope:
Need to enhance new fields into Service level DSO
Out of Scope:
Cannot consolidate the changes into current existing DSO, so a new staging DSO is used.
Solution Summary
1. Need to create the new inf objects for Actual goods movement date, Net price & Reason for rejection.
2. Need to create a new staging level DSO, add the newly created keyfigures in the DSO and make the season & Customer grp2 as navigational attributes in it.
3. Need to create a new infosource & map the infosource to the staging level DSO.
4. Need to map the existing service level DSO with the Infosource.
5. Need to add additional logic for the key figures like Ontime confirmed, Ontime ordered, Late ordered, Late confirmed , Early ordered & Early confirmed based on Customer Grp2 & Season.
6. Need to test the changes in BPD(BW 7.3 Develpoment).
7. Need to collect all the changes into the transport requests.
9. Need to do fresh initialization once the transports are moved to production(BPP).
Test Plan
SNo
|
Test Scenario
|
Expected Results
|
1
|
Check if the new staging level DSO has all the requires characteristics & keyfigures.
|
New staging level DSO ZSD_OSSL should have all the required characterisctics & keyfigures.
|
2
|
Check if the key figures defined with new logic are populating data correctly.
|
Key figures defined with the new logic should be populated correctly.
|
3
|
Check if the mappings are defined correctly between the DSO''s & Infosource.
|
All the mapping should be defined correctly bewteen DSO's & Infosource.
|
4
|
Check if all the objects are collected into the transport requests.
|
All the changes should be collected into the transport requests.
|
Solution Details
1. Need to create the new infobjects for Actual goods movement date ZACTGMDAT, Net price ZJ_3ANETP and Reason for rejection ZREA_REJ.
2. Need to create a new staging level DSO ZSD_OSSL and make the season 0AF_SEAN_ZBPC_SEA & Customer grp2 0CUSTOMER_CUST_GRP2 as navigational attributes in it.
3. Need to create a new infosource ZIF_ZDSOSSL & map the infosource ZIF_ZDSOSSL to the staging level DSO ZSD_OSSL.
4. Need to map the existing service level DSO ZDSOSSL with the Infosource ZIF_ZDSOSSL.
5. Need to add additional logic for the key figures Ontime confirmed ZOTCONQTY, Ontime ordered ZOTORDQTY, Late ordered ZLAORDQTY, Late confirmed ZLACONQTY, Early ordered ZERORDQTY and Early confirmed ZERCONQTY based on Customer Grp2 & Season.
6. Need to test the changes in BPD(BW 7.3 Development).
7. Need to collect all the changes into the transport requests.
8. Need to do fresh initialization once the transports are moved to production(BPP) to populate the staging DSO.
Issues
Since Customer Group 2 navigational cannot be used for calculations in the routine logic, we had to introduce the staging DSO and infosource.